Snippets to import data into two related CCK nodes from CSV data

I did some testing of that module a few months ago, and looked at the code, looks like it could do the same job as my snippet, assuming it is CCK friendly (don't remember that at all, but it might be more CCK friendly than my snippet, considering the vocabulary hack at the bottom :) ) except it isn't available for 5.0, so would have to look into that, maybe find out from the author his road map on that.

Hope the code is useful for someone, and I will report on what I see on the existing import/export module.

Victor Kane
http://awebfactory.com.ar

So, making an adjustment in the code (taking into account that node is an array and not an object until we make it so, just before node_save), the full snippet works perfectly as follows (notice that we have inserted the assignment to node['taxonomy'], and commented out the previous call to db_query after the call to node_save, which now requires nothing further):

<?php

// Written by Victor Kane - victorkane at awebfactory dot com dot ar
// *** This script affects your database
//
// CONFIGURATION

    // Change the value below to TRUE when you want to run the script After running, immediately
    // change back to FALSE in order to prevent accidentally executing this script twice.
  $active = TRUE;

// CODE
  include_once "includes/bootstrap.inc";
  include_once("includes/common.inc");
  drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

  $content_type = 'contacto';
  $content_name = 'Contacto';
  $archivo_datos = 'backup/test.csv';

  if ($active) {
    if (user_access("administer content types")) {
      insertar_contenido($content_type, $archivo_datos);
    } else {
      print "No tiene permisos para administer content types";
    }
  } else {
      print "exportar-empresas no ha sido activado. Ver variable $active al principio del código fuente";
  }

function insertar_contenido ($content_type, $archivo_datos) {
  $handle = fopen($archivo_datos, "r");
  $theHeaders = fgetcsv ($handle, 4096, "\t");
  $lineno = 0;
  while ($line = fgetcsv ($handle, 4096, "\t")) {
    $output .= '';
    $valueno = 0;
    $lineno++;
    $output .= '<ul>Línea: '.$lineno;
    $observaciones = '';
    foreach ($line as $value) {
      if ($value) {
        $output .= '<li>'.$theHeaders[$valueno].': '.$value.'</li>';
        $observaciones .= '<li>'.$theHeaders[$valueno].': '.$value.'</li>';
      }
      $valueno++;
    }
    $output .= '</ul>';
    $node = array();
    $node['title'] = $line[3];
    $node['body'] = $observaciones;
    $node['type'] = $content_type;
    $node['format'] = 3;
    //$node['taxonomy'] = $_REQUEST['taxonomy'];
    $node['name'] = $content_name;
    //$node['date'] = $_REQUEST['date'];
    $node['status'] = 1;
    $node['promote'] = 0;
    $node['sticky'] = 0;
    $log = 'Importado por importar-contactos el ' . date('g:i:s a');
    $node['log'] = $log;

    $node['field_empresa'] = array (
    0 => array(
      'nid' => db_result(db_query("SELECT nid FROM {node} WHERE title = '%s'", $line[2])),
      ),
    );

    $node['field_cargo'] = array (
      0 => array(
        'value' => $line[22],
        ),
      );
    $node['field_saludo'] = array (
      0 => array(
        'value' => $line[17],
        ),
      );
    $node['field_nombres'] = array (
      0 => array(
        'value' => $line[54],
        ),
      );
    $node['field_apellidos'] = array (
      0 => array(
        'value' => $line[55],
        ),
      );
    $node['field_mvil'] = array (
      0 => array(
        'value' => $line[15],
        ),
      );
    $node['field_telfono_particular'] = array (
      0 => array(
        'value' => $line[14],
        ),
      );
    $node['field_buscapersonas'] = array (
      0 => array(
        'value' => $line[16],
        ),
      );
    $node['field_e_mail'] = array (
      0 => array(
        'value' => $line[89],
        ),
      );

    // Marc of funnymonkey.com suggestion: the integer '2' is tid
    $node['taxonomy'] = array(2);

/*
  // this code, from the autosave module, is unnecessary, since node_save will do it for us :)
  $node['nid'] = db_result(db_query("SELECT id FROM {sequences} WHERE name = '%s'", 'node_nid')) + 1;
  $node['vid'] = db_result(db_query("SELECT id FROM {sequences} WHERE name = '%s'", 'node_revisions_vid')) + 1;
*/
    if ($node['title']) {
      $node = (object)$node;
      $node = node_submit($node);
      node_save($node);
      print $output;
      /*
      $nid = $node->nid;
      $tid = 6;
      db_query("INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)", $nid, $tid);
      */
    }
  }
}

and afterwards, using the devel module, we can see the value has been placed accordingly when we hit the "Devel load" tab, and see:

As for the call to node_submit, I included it because when I saw it included in the autosave module, I checked out the CCK code, and it looked like there was a lot of housekeeping done possibly on certain kinds of CCK objects, so... I may be wrong but I went ahead and included it. It does work without that call, though.

Thanks, once again, Marc!

Victor Kane
http://awebfactory.com.ar

I discovered the answer to this by trial and error. Try adding this:

$node['name'] = $username;

...where $username is the name of the user doing the import, as seen in the {users} table. That did the trick for me; $node['uid'] appeared to have no effect. Note that I am also using a slightly different approach to the import than the script referenced in this thread. My approach is to generate a "faux" form and then submit it with drupal_execute(). The whole thing is packaged in a custom module so I get the benefit of an upload form, validation, etc., for the user who will be doing the uploading.

--Buzz